﻿--新建通告(多个单位可见)
Create proc [dbo].[proc_Notice_Create_s]
(
	@Fid int,
	@Title nvarchar(200),
	@Content text,
	@UpName nvarchar(20),
	@IsAll bit,
	@IsDing bit,
	@CreateTime datetime,
	@UpTime DATETIME,
	@CompanyId INT,
	@CompanyIdList NVARCHAR(300)
)
as
	--Declare @CompanyId int
	--Set @CompanyId = (select Companyid from aspnet_Users where username=@UpName)
	insert into Notice (Fid,Title,Content,UpName,IsAll,IsDing,CreateTime,UpTime,CompanyId,CompanyIdList) values(@Fid,@Title,@Content,@UpName,@IsAll,@IsDing,@CreateTime,@UpTime,@CompanyId,@CompanyIdList)